package com.acwer.drools.dao;

import java.util.List;

import org.apache.ibatis.annotations.Select;
import org.springframework.cache.annotation.CacheConfig;
import org.springframework.cache.annotation.Cacheable;
import org.springframework.stereotype.Repository;

import com.acwer.drools.domain.SSBM;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

@Repository
//@CacheConfig(cacheNames="SSBMDao")
//@Cacheable
public interface SSBMDao extends BaseMapper<SSBM> {

	@Select({ "<script>", 
		"select * from ADRG_SSBMDY", 
		"where ssbm in",
			"<foreach collection='list' open='(' close=')' item='id' index='i' separator=','>", "#{id}", "</foreach>",
			"</script>" 
		})
	public List<SSBM> selectByJbbm(List<String> ls);
	
	@Select({  "<script>", 
		"select * from ADRG_SSBMDY_CB", 
		"where ssbm in",
			"<foreach collection='list' open='(' close=')' item='id' index='i' separator=','>", "#{id}", "</foreach>",
			"</script>" 
		})
	public List<SSBM> selectByJbbmCb(List<String> ls);
}
